import openpyxl

def getExcel():
    workbook = openpyxl.load_workbook('test_data.xlsx')
    sheet = workbook['Sheet1']
    test_data = []
    for item in sheet.values:
        if type(item[0]) is int:
            templist = []
            for col in item:
                templist.append(col)
            # print(list1)
            test_data.append(templist)
    # print(list2)
    return test_data

if __name__ == '__main__':
    print(getExcel())



